Stored Procedures [dbo].[BAEInsertError]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@pStackTracevarchar(2048)2048
@pFriendlyErrorMessagevarchar(1024)1024
@pErrorTypevarchar(1024)1024
@pHttpRefervarchar(256)256
@pHttpPathvarchar(512)512
@pHttpHostvarchar(128)128
@pHttpAllvarchar(2048)2048
@pUserIDvarchar(64)64
@pCookieDatavarchar(2048)2048
SQL Script
create procedure [dbo].[BAEInsertError] @pStackTrace varchar(2048),
     @pFriendlyErrorMessage as
varchar(1024),
    @pErrorType AS varchar(1024),
    @pHttpRefer AS varchar(256),
    @pHttpPath AS varchar(512),
    @pHttpHost AS varchar(128),
    @pHttpAll AS varchar(2048),
    @pUserID AS varchar(64),
    @pCookieData AS varchar(2048)
AS
    INSERT into Error (StackTrace, FriendlyErrorMessage, ErrorType, ErrorDate, HttpRefer, HttpPath, HttpHost,
    HttpAll, UserID, CookieData) values (@pStackTrace, @pFriendlyErrorMessage, @pErrorType, GETDATE(), @pHttpRefer, @pHttpPath, @pHttpHost, @pHttpAll, @pUserID, @pCookieData);

GO
Uses